Opening Access queries through ODBC

ODBC gives you more control over which parts of a database you can use. For this reason, using an Access query through ODBC may require a few extra steps.

To open an Access query through ODBC
  1. On the File menu, click Options.
  2. Click the Database tab.

  3. Select the Views and/or Reprompt user when connecting check box(es).
  4. In addition, you can specify Table name LIKE and Owner LIKE options, if you wish.
  5. Click OK to exit the Options dialog box.
  6. Create a new report and choose ODBC as the data source for your Access database.

    Tip:    Choosing ODBC as your data source automatically logs you onto the server.

    If you did not specify a particular Access database file with your Access ODBC data source, the Select Database dialog box appears.

    Note:    If your database requires a user name and password, or any other log on information, a log on dialog box appears.

  7. Locate and select the database that contains the Access query you want to use and then expand it.

    If you selected the "Reprompt user when connecting" check box in the Options dialog box, the Allow Reporting On dialog box appears. Otherwise, skip to Step 9.

  8. Make sure the Views check box is selected and click OK when finished.
  9. Highlight your query, click Add and then Close.

    The Design tab appears along with the Field Explorer dialog box. Your Access query, and all fields associated with that query, appear under "Database Fields."

Note:    You cannot use Access Action queries or Update queries in Crystal Reports. However, you can use Access Select queries and Cross-tab queries.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com